SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341170 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341170 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469596,552479,1044452,837000,444275,26412,891164,174198,779250,222896,724532,272930,633138,11062,378684,498899,844713,183439,988540,186019,214032,540096,172220,703131,44071,573118,817002,603194,456482,637288,94083,706697,123071,781683,20142,770066,881932,856240,473728,473694,912104,29564,341641,632578,450936,520599,192827,819101,537669,111932,155266,848194,977384,399007,59959,427275,585773,735734,289904,267319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002655s ]