SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023838 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023838 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661596,352979,66611,138769,133879,135658,779236,786839,84109,416248,916413,671191,652017,978791,350712,351473,913089,412145,70584,673921,16014,638797,36950,195992,23610,100969,18818,953127,581085,109714,613005,550707,151533,900162,884402,110237,899882,51862,820819,670025,513498,1007692,588283,418833,61388,246034,483576,775454,80694,92792,543866,253282,2359,264994,227858,401824,933747,127857,589901,847868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]