SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414978 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414978 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722798,236082,549849,400708,219859,303519,74339,32439,1030094,552936,384635,873138,714015,639924,314620,637832,341834,264130,160843,822404,354370,340974,959896,571518,187241,341522,111765,479016,168244,58405,26899,952619,170731,1037302,739271,213463,408216,518073,540060,542268,244833,938206,1628,937095,143765,839555,636480,78321,624666,219632,554839,770729,387449,984234,459434,924444,807513,686864,1045739,844102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]