SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011026 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011026 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409703,254839,487936,805070,634391,539617,209776,753252,371487,976428,606349,667453,346533,354756,638013,450393,622240,353048,915143,26654,605521,319419,731217,568705,424275,945222,799680,321237,803336,505053,830947,744632,588086,676874,155495,155462,293961,963121,956459,208771,317142,549297,860973,811315,1039675,249670,666683,191839,304145,919946,244352,29761,475016,552786,845681,892014,299239,572758,755428,545806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]