SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266439 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266439 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010110,616950,173156,912572,683261,828879,382611,515814,965319,86802,192905,464265,260435,522383,790323,960917,1017356,658946,67730,193990,196704,595861,821940,774815,112211,331828,786444,743349,443712,937547,669612,851839,181050,862326,450263,599629,69114,57520,650469,293873,671273,312566,15934,879329,896172,144184,374766,880048,562388,39417,447015,1008773,973804,193191,290983,140271,193631,570731,482210,943879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]