SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541062 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541062 [ RunTime:0.003279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495554,600324,145751,726331,105413,349257,56149,453934,240336,264734,297688,346050,771224,160240,719331,875277,126010,778938,983053,389848,141509,455991,825184,145680,260581,701910,131358,552677,469488,576041,448524,217487,893903,439780,722551,814593,804120,481997,691647,976903,250459,176494,491386,722191,748753,684596,790736,923777,474180,772988,87543,127984,654438,181612,762434,875396,368505,891756,343673,731791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]