SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001694s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001393 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001393 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909837,152112,795575,325872,190373,727735,749561,130411,724003,53864,405936,192729,938361,207393,272084,786247,403014,988294,608134,376924,269654,804175,262435,409558,764172,557800,580634,685551,925526,643285,263140,190466,967780,463180,565487,367386,785711,373968,507233,788984,926144,463657,586961,844670,1037168,850491,807362,732542,121292,829440,465377,383592,686351,568145,729774,223807,838415,769129,279398,143584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]