SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29642 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29642 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675291,967024,383189,858946,215803,361373,320012,4818,1005335,699742,458968,605868,490185,38234,840229,593476,47723,141288,937534,718615,1034330,743807,191167,606147,201196,569693,936390,66660,333718,110515,884052,156866,314950,554874,947018,913523,790405,66354,96979,68971,460088,42530,594141,569227,574849,478468,960191,442674,3708,26586,993286,661207,126652,227790,551723,550502,275499,597471,300489,1043721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]