SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3422 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3422 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280452,221168,962233,1045891,47759,384312,160424,849725,725574,753350,774471,297359,137982,679478,525667,2416,100589,495447,558959,628116,808700,1022828,141076,110406,182284,263429,682409,943487,82040,547358,589205,447155,776791,678560,999474,280014,1018742,351151,476628,269045,398439,755355,930198,298548,947735,854484,55253,752862,876089,709770,544200,917804,83001,1031927,251292,568739,193779,250221,239838,491944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]