SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005396 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005396 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447358,139029,27700,199148,534959,98791,41673,442512,263586,218342,499519,415644,830359,834320,345479,577592,485283,824247,194131,802335,82459,277179,1012035,789770,569681,835229,251418,45101,845320,458495,11080,944029,308958,514409,750688,156588,841203,152003,254636,773190,863968,298150,742735,813163,568951,944983,360501,817304,912610,43939,420287,886675,25663,975372,295564,232572,872058,1026655,393197,878987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]