SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034580 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034580 [ RunTime:0.003186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654468,228404,789642,550214,648146,229236,85491,330868,154133,6161,489581,426563,973168,953254,219274,585688,889938,367698,899358,824960,314800,61413,319647,447524,257499,853827,351462,338810,899297,597160,41867,237182,663068,474020,765238,405521,410957,52223,64777,179280,568151,469622,819316,763825,447645,927390,1012149,480641,852011,1029926,222030,1047083,101448,687033,575512,141772,864825,872791,920024,222458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000950s ]