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` = 1046304 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046304 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692730,22527,449920,55965,305522,840817,141906,531457,1040502,467877,961204,873137,43526,633652,281538,355174,715575,932056,657167,325476,916319,601778,475232,283144,622154,718916,911133,263122,667206,333737,763935,856299,224883,420388,1036510,1011993,751972,1034792,377699,702516,627258,487874,649143,620170,117827,589873,365222,516450,1021642,216852,1020533,429466,388670,21792,729874,524989,712901,931183,977658,1036434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]