SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509238 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509238 [ RunTime:0.002764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185833,1043304,647528,940080,150542,639653,835458,849141,136276,51432,386623,625243,856854,523039,427603,477841,140838,715788,829617,418238,942857,661314,733047,212258,304869,799164,186116,49212,498550,66078,155123,366849,1017579,755616,22901,527473,164645,387521,140788,180383,962605,870251,326938,416814,780279,414218,475400,539589,724092,764527,240942,414418,106736,424865,889295,315626,1011267,813678,25240,270678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002187s ]