SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001627s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574266 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574266 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834404,438440,1034181,586923,202616,643329,221490,404950,851660,228298,1002056,1046737,152942,1047717,464651,566938,139648,369077,38864,333711,166359,403027,556750,735073,566583,409211,241267,521271,36070,368169,834579,674992,200853,966000,1048449,570893,564255,91010,587789,1034298,934113,384546,1016013,962926,327965,479489,88259,635495,865107,62988,983798,225879,306342,669928,652805,482609,646969,271655,823951,1009694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]