SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527460 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527460 [ RunTime:0.003885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703635,955716,257343,675055,290390,630324,149235,727323,1017951,325808,747147,503926,377194,630570,314414,840318,681107,88966,953084,772039,140174,197635,1044999,436944,885254,659394,333347,224893,1000517,481102,640369,354870,360001,807983,394909,312748,276534,349128,601790,590227,271475,1021660,34352,311373,487297,152483,576397,494269,476148,1017336,86237,865669,378899,293250,908404,111954,481795,818779,970782,995533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]