SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 362563 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 362563 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010020,946476,597127,247136,727274,513440,922095,412281,400275,103131,837571,1015653,847228,589457,257778,718956,10411,525459,227564,646027,1010179,37993,115222,99082,554667,622900,974647,920770,164213,526781,722671,614531,279448,615067,630171,16773,172678,306198,810683,481645,75295,385173,326105,122424,596799,482214,426319,76705,475092,526145,178342,922738,790437,145102,376653,555686,639543,165829,682857,11025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 362563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 362563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]