SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298263 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298263 [ RunTime:0.002892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498567,709820,332320,488010,105991,856443,363380,174723,489871,988948,709934,912053,343831,537961,475214,705730,381707,192085,174564,366064,846887,810491,1034451,606602,320926,736803,507941,727740,725438,73829,739779,869001,225779,481348,447211,181467,895902,346455,631964,154030,257413,721517,882484,195045,108030,803463,416642,919464,890764,146220,474782,576208,898434,641265,744072,540753,449420,513064,268372,85997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]