SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415082 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415082 [ RunTime:0.002949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262257,940548,236050,546626,668162,391970,852705,874105,907038,362718,947379,939970,997771,711380,858903,852328,873326,310798,361196,617521,515788,19510,6570,28758,987890,18458,354987,746634,827901,468701,167445,89802,572091,702040,515862,113203,598515,262511,675544,246483,144963,172059,32064,312222,752736,404364,1046150,734947,821477,909821,348502,424309,411096,136744,529782,429940,188453,822195,958080,728841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]