SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504304 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504304 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353174,212027,337089,854308,891734,226778,1019876,555295,791425,370410,835246,887994,661310,771683,474552,151539,695196,727611,315635,196138,474827,346105,471055,18132,600284,675465,549503,600228,660290,316901,202896,345477,113407,904639,547202,695839,60541,972558,992730,83556,512260,772903,86231,553028,354228,213176,108805,251161,48108,244495,261642,1043467,597645,884272,642156,122136,424578,557720,965653,141519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]