SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542418 LIMIT 1 [ RunTime:0.000519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542418 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358723,832800,1048889,905070,1024583,265714,821096,250592,869195,87403,733297,465478,116315,166114,875806,171635,144965,913546,220671,591798,258088,651911,894849,782777,425298,409441,852852,883094,826242,482175,909905,509857,139230,273749,52657,939212,622065,284684,943589,715980,780882,122999,503377,329004,164451,288156,835186,439121,998675,220626,845491,168215,223117,536847,676932,53716,167034,149974,1001430,796802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]