SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003067s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011442 LIMIT 1 [ RunTime:0.000971s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011442 [ RunTime:0.005028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355356,74396,67789,224405,487723,22665,301844,474312,980194,290835,611272,767050,991943,1014884,888454,430298,828358,66112,940103,285014,512366,650824,509354,1042338,262656,797767,216455,1020006,33389,1041581,589632,625390,108485,871858,810087,912305,747644,866941,833123,933606,545032,310251,117252,665314,659926,819179,605305,78953,714633,327029,785806,1009958,136195,211983,674755,202767,231666,686300,217886,48866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]