SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543846 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543846 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805689,569887,272273,295839,501833,462321,1021026,126596,1026311,444466,129779,308203,947771,545363,160439,164352,723652,167172,381820,962655,671493,741366,424275,868836,371810,243288,199563,834806,255830,404807,14602,575030,654543,297214,943188,309859,378154,296930,86098,102206,993742,922641,813952,742413,951488,1045308,641062,736597,223576,794939,579123,592506,586652,346128,309773,547485,754057,864611,519794,28211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]