SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 125043 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 125043 [ RunTime:0.002927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797775,811817,416495,12039,38058,242833,213691,115296,832059,157673,520109,40050,371669,944748,746273,348970,375658,397850,421969,303021,1001095,421629,813819,1018208,635232,1039907,201400,397987,487203,810293,124900,1046472,1030589,1027818,46333,395924,939428,306729,382057,392571,633104,1021388,450279,754552,993080,1001232,888848,587296,192370,808231,383059,719309,60777,459028,1022108,559882,570093,246381,536951,286793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 125043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 125043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]