SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412224 LIMIT 1 [ RunTime:0.000638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412224 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786288,1044761,792158,824467,373750,841616,854131,829210,878119,1044452,617815,788979,1048764,79857,215876,449429,517042,876312,782878,550952,719680,12583,320323,193932,991875,123292,630361,946483,260498,512359,124766,506799,37457,988574,763777,957423,717203,19386,852545,27822,907822,55605,155363,981694,182533,191572,80874,912157,254308,796709,441073,694696,394311,424334,899980,480426,972263,642417,401486,473854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]