SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540328 LIMIT 1 [ RunTime:0.000631s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540328 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194051,371985,597759,118201,318109,52941,126697,699420,327538,270305,719610,123805,739622,219433,524608,935335,343064,680197,563306,781144,753091,353998,372213,621245,159411,284260,228896,860145,926078,236120,770176,658077,432414,257301,687555,876361,85749,222441,433234,384342,413592,425927,903877,960104,389955,377114,71396,1012184,835150,496137,266452,180446,383629,604919,549598,213259,13517,701141,962866,388342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]