SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531390 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531390 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38481,106823,612360,558884,711533,687068,178173,4654,960538,716865,219868,465950,1004448,100397,309330,150188,580904,83865,530905,772047,78551,1046101,1013911,611344,143216,543235,975130,912742,179918,757085,900402,91234,339932,266037,228216,6605,21388,455758,155554,1030854,896743,245557,105052,435873,707137,600582,1028263,166832,479549,687344,344672,624204,251174,313364,655327,485206,300675,719348,233652,916251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]