SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38781 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38781 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423501,591776,51213,796671,652109,695941,354578,1044188,4679,164312,20461,804793,1005181,324373,206661,685600,410365,36237,538132,645938,1016742,592665,49584,626780,200098,487175,826490,377323,840517,292774,286170,164530,169827,400001,426718,155944,147793,588190,64664,538310,256463,219113,323351,276945,313848,593441,536258,935976,662773,395837,909298,451980,476988,497504,472079,807015,738140,411452,622498,611991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]