SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444309 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444309 [ RunTime:0.004099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972976,427884,1027982,532658,230786,198326,659020,252962,313063,226615,578763,547628,998359,476973,986642,447256,907248,299438,538626,864654,356008,141270,90862,87246,219295,851227,863623,13966,176947,745142,623274,205388,331655,929108,1039091,998234,316671,400237,618035,786202,954452,933289,338522,558712,205449,164203,861334,372868,8240,607269,780112,815699,306019,68837,854098,118081,258349,203873,90037,804514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]