SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398504 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398504 [ RunTime:0.002519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857005,827496,498909,102724,129946,257449,471999,764931,350665,839830,513449,354541,568914,621054,149079,931310,296708,279699,900528,459940,227455,1020463,131048,246381,979018,201879,783929,683760,540686,368671,58440,798075,242908,276446,818542,466964,618780,111885,15051,376923,202226,249394,321195,41272,983808,102053,495769,814980,384052,366258,1014434,389478,756552,505759,616874,778682,964891,681043,963571,568611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]