SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422955 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422955 [ RunTime:0.002051s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932838,344420,565571,26038,507842,443189,390046,566238,67517,501045,972139,279425,639532,161674,1019228,619282,357458,563494,448961,183301,710960,598811,577085,58186,231609,251772,846495,656452,882297,653727,128276,677199,400958,976314,986828,963796,164435,62690,344481,753442,289637,656773,53019,237803,463149,251687,174168,49863,591524,962532,914370,82369,332122,985790,582553,732239,412200,564598,458318,799140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422955 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422955 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]