SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 184301 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 184301 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509069,809686,474200,655601,728104,61847,653339,503892,440093,490555,56758,157048,402319,814399,42635,695705,278047,217325,516814,901184,614515,950279,798661,333954,636487,501311,854567,538848,760354,264071,483034,30839,307888,833630,590032,745486,53017,885014,219397,27183,276381,853065,211282,407153,877202,857413,22564,116423,537798,780302,249177,631829,625558,726609,817654,899789,853534,171727,585987,881784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 184301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 184301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]