SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541978 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541978 [ RunTime:0.001472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199090,483296,899366,934920,384378,814192,611391,58332,988497,346098,1012172,227697,863708,802194,871327,381242,931127,971802,974598,763341,172297,272532,649772,609498,306902,828780,399422,974011,637265,261453,1017465,366259,857182,614896,31787,791959,533172,508247,802982,373048,312427,765452,884827,827425,488937,772841,551292,640343,619033,174557,681535,639727,371710,627266,18647,745484,773748,136927,19051,584972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001926s ]