SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036600 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036600 [ RunTime:0.002636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786323,549804,11004,152696,917079,283886,332159,104159,835698,158254,587536,367836,181585,213246,151818,950083,774407,206369,586296,178092,464146,349960,43637,140529,1026372,346591,32676,658993,847693,853567,386359,902273,108915,516748,350548,433876,49527,642077,483462,350049,1021566,552834,192982,648827,525556,955626,891727,262906,117544,905310,30300,147462,424871,557771,651684,263922,848877,380428,767865,11019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]