SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456845 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456845 [ RunTime:0.001498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570856,1026127,1048706,324846,624166,444284,576044,471450,205033,1030924,984739,579516,685528,150439,475427,917718,634834,629583,292961,1042114,57405,1037101,91288,754098,372999,995856,629934,695530,148590,460316,726305,866283,551094,263803,328290,3,133283,216049,956616,205243,257631,850013,515895,959488,896638,1027878,746354,948483,932661,579281,140582,820049,153937,146799,141028,791572,652309,51036,475563,149277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]