SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544075 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544075 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829434,943234,483456,425208,455939,45463,842518,121506,505259,265356,655250,422120,169778,622383,98827,185132,793248,77695,52016,226377,960622,720037,437578,324180,161667,576090,67508,427661,898193,1011322,937873,1034537,305525,905413,242750,336847,250794,634540,539317,93359,142895,18086,730801,807901,234046,672291,878312,865434,616417,1008481,175319,245641,510310,382813,1042204,591900,773312,893031,94233,714349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]