SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 822905 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 822905 [ RunTime:0.002802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564763,262384,318794,190221,172123,472723,559006,197590,858922,541875,1033938,369477,726631,243682,979794,16692,998010,413393,896744,519420,132302,257140,448559,530110,991706,967330,474720,875651,822065,17885,480763,749170,587905,659846,684422,458015,190447,301560,486031,870236,724873,134323,972116,211487,46059,535795,684517,899394,292792,956953,109488,455539,861802,274684,964059,364778,939986,934968,818258,590343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 822905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 822905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000844s ]