SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532132 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532132 [ RunTime:0.003193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041029,817590,526512,380176,859282,998485,895097,645581,665988,53543,751599,311942,596850,132778,325523,32688,1023909,414542,636817,672080,305734,785919,160194,1047690,55287,878213,297352,442673,534947,551656,787621,723580,1007569,117724,692303,650554,170124,382890,434522,745074,395704,637872,737283,1025666,399157,826068,381050,617899,366273,554999,346717,642868,1009684,749864,832645,402832,827562,831481,992942,632086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532132 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532132 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]