SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411834 LIMIT 1 [ RunTime:0.004754s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411834 [ RunTime:0.002570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292245,292757,945216,273671,544504,479685,379135,291189,905931,715864,186937,1028309,765709,1036085,894170,513915,850833,239200,113711,161216,494695,392244,847398,898797,641985,161919,11210,455318,367804,811644,160913,438051,719281,400225,321143,16596,384471,521845,246226,711656,978119,924661,559702,948864,670662,100755,196916,639065,198554,858436,402202,401966,866993,954270,620451,636284,455541,340569,146839,290480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003815s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001099s ]