SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531914 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531914 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276979,398604,384559,780124,788166,149564,509501,732027,743376,894141,843192,1033123,180813,118742,6311,820591,246282,28737,820032,863158,858469,93375,707010,669111,746078,168065,405077,947610,53176,703970,338797,216765,757753,970158,1020235,733928,795907,109776,774226,152142,873839,628476,75165,1042427,635119,225536,1036437,564905,1018977,870847,569777,279353,343207,112009,1017492,610023,724453,986191,110027,281705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001148s ]