SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039270 LIMIT 1 [ RunTime:0.001181s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039270 [ RunTime:0.003233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492366,718793,272985,444856,797294,797454,784530,840413,426014,464942,28605,607764,291967,312666,24255,309987,609380,689623,663670,957183,425683,790565,73439,1023181,688259,501110,984880,104554,150301,43158,1030710,235146,76540,431924,751187,939249,366617,217678,308455,785217,868078,812963,551561,145155,625937,524704,595548,925326,300395,688236,369435,874132,91872,716710,609618,75809,403839,35038,594887,95260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.034773s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002781s ]