SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001659s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024860 LIMIT 1 [ RunTime:0.000556s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024860 [ RunTime:0.005939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799575,1001970,227324,869058,935579,950104,480777,736086,163182,581327,180636,905572,86846,75345,691177,760329,22734,271712,447546,210201,889980,272147,409464,1001998,851211,237543,777073,969314,332768,1017466,177321,50514,436295,935132,511138,371293,1006913,551812,855416,338465,684653,672576,467185,579040,663495,812910,1044629,274861,565178,481891,107363,136238,827189,764074,706189,958579,398257,932401,582644,746404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]