SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001606s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563898 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563898 [ RunTime:0.002583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290642,632181,729431,531149,42954,384147,305210,68026,917863,395691,81164,763554,588988,999428,217450,196863,196335,1042722,395992,561605,604638,614140,949675,438019,422423,151676,105824,782198,360342,1029518,374293,346769,529275,625072,477206,37677,372933,652904,248354,444485,483229,416629,756071,632204,68670,428988,1021137,1023993,67065,86404,215273,179565,597262,312500,760422,760478,234766,840472,169434,729650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]