SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555028 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555028 [ RunTime:0.002031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934582,778292,439893,965315,634285,466207,956690,993534,388049,427933,719638,225763,744780,1007743,927274,661547,40967,762382,908959,143886,60410,994449,721056,1015129,744752,42403,48651,892500,639785,571095,1002558,394626,573807,145344,541201,448511,323967,128697,692806,649198,59059,710480,976351,623818,607885,385030,243026,883052,762008,116638,132438,632256,499505,718019,587560,748372,279542,1039800,148760,67935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]