SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575016 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575016 [ RunTime:0.002651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233499,362767,153548,374424,322992,736036,384212,442,250814,1008081,877875,88511,169349,697438,657700,811346,24679,769430,437318,511911,6541,181334,531217,438019,218979,125775,151164,931933,875611,694972,4329,282374,489651,52696,516967,843100,997644,110280,406621,214188,435537,489597,1017288,98191,328023,50275,675850,439695,65448,403406,579233,958038,23755,285155,410664,854174,13513,827096,212952,192328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]