SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469804 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469804 [ RunTime:0.002561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622351,300431,168847,283955,158053,975315,682722,19249,764847,855368,386996,746784,383174,523174,555332,1031352,118046,51257,65788,192865,509169,550776,862340,751171,466908,27420,611856,593046,671198,8970,565809,926449,1023651,92527,1046778,41073,251855,37002,555561,589737,1041642,672321,630854,741120,736223,3106,1004509,250010,293500,1003100,939179,403241,891205,629346,143819,439573,855387,821377,365734,917046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]