SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420678 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420678 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694317,276287,580316,924376,15463,661623,198021,485965,968985,631372,242912,848425,3159,844595,142725,169737,274801,379952,630626,877385,680386,302001,20750,465544,74342,115483,536943,845300,682547,993878,836481,934207,923151,507659,709424,566779,359832,478541,297689,837037,592058,695634,25296,192786,367235,29383,968535,768007,972288,532458,620043,1029722,740434,368742,966271,459612,513996,641188,35382,402734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]