SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445367 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445367 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417202,202462,930781,103043,225292,1005234,516894,63877,392359,1027691,876853,870219,1000738,507305,958045,792633,596792,671999,958881,364722,535796,627249,126506,815670,100267,159471,731145,95458,968450,335290,484140,449334,740478,94471,642549,503043,739804,895252,337434,219058,659862,10766,661832,901689,1023725,867504,539165,685762,974230,231485,922,634484,1024932,867147,882053,875508,518886,258305,477300,1022858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445367 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445367 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001236s ]