SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520068 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520068 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340643,49294,279936,630201,355620,338086,705195,312261,119143,569646,409356,783087,467668,679674,675697,827564,28885,750429,119719,301389,870489,246734,712139,672770,117506,474384,478535,846854,375943,919922,94801,667783,971705,828832,512648,834157,97503,891096,845039,119939,327290,354764,478948,63693,448257,547890,521773,929255,606614,316451,211830,473769,173163,761279,309437,24398,511475,175801,162570,555236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]