SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526410 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526410 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674312,1028977,510534,373727,140526,363457,373999,849415,721215,672357,91351,30808,687623,754710,603272,80581,218721,1016630,572487,730849,177404,142037,444074,680244,358421,900726,590558,782888,1027682,631906,698057,721243,530679,271289,1042449,177566,398470,396104,735073,883446,166298,490605,851702,205578,114863,836720,800052,510245,927933,355918,81113,492745,858308,91706,244171,828183,611857,540512,111021,272328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]