SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466048 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466048 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417976,508260,326365,825474,537034,676658,949994,875232,1028409,404190,1042859,148272,773083,984671,447330,219758,887065,1004342,828503,952385,969320,434965,990083,496957,337107,476245,1012053,813738,369530,948628,267914,923568,916823,950887,177067,855678,56882,1012970,96480,217225,47932,22284,713384,465001,493528,387905,763851,127995,962427,466885,1046636,910755,359281,59349,382670,653990,445342,63337,628557,776685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]