SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981823 LIMIT 1 [ RunTime:0.004441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981823 [ RunTime:0.004787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560920,20849,838667,162504,760983,608732,538541,533020,548455,74525,24300,282940,799047,127924,97858,15486,259041,891651,641484,682979,646473,931990,667544,788362,178084,639739,85337,187498,704569,355774,858316,262831,646580,410880,924396,565759,678743,501440,902399,746267,869489,279582,135542,881544,364578,731749,1035551,870846,725165,547368,653879,334725,603462,766745,717954,780211,296996,375769,309163,150455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]