SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436976 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436976 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12525,938189,230098,631732,162145,277511,743705,583233,546535,564169,545672,547891,324124,240827,413624,31397,837949,399725,403153,811755,769382,735616,111920,824770,911501,4323,638513,844080,280580,83615,615415,181066,70665,1047482,389830,314219,178149,412912,959818,552711,443272,598000,21425,350206,91934,637180,1045880,726776,185708,10672,119353,775143,109774,667432,227505,775205,102612,372017,571777,990842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]