SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466953 LIMIT 1 [ RunTime:0.000676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466953 [ RunTime:0.003436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799300,26991,297201,480096,905429,658383,659615,924619,451837,113312,886248,539652,122151,691229,290959,363751,231441,236910,1012234,694484,58127,763668,954974,286323,211113,328223,977167,190921,710361,154385,155120,366006,201874,765495,29733,508310,507584,261343,1020940,818590,256720,858018,1009052,202583,643479,192786,37228,847198,435889,560708,425032,654864,117167,941491,553013,1008779,883181,951246,471855,864188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]