SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029096 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029096 [ RunTime:0.002715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804897,619905,531696,679181,209385,652324,551688,819034,491429,111843,413101,535581,391497,999984,760808,949911,574915,390234,300018,198103,82980,590362,47969,711653,739233,62072,490892,410642,905830,954702,715319,791,356070,628250,640627,289281,841327,597322,392269,175607,833244,407845,1020423,670739,510359,897860,222717,687390,149279,452728,383093,281617,763723,298702,354122,721097,26695,26107,378072,19738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]