SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348820 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348820 [ RunTime:0.003934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407108,14205,15214,362923,279631,498067,130529,46216,621938,19223,644221,775027,821325,439608,914841,146124,1046547,968222,202709,762324,62230,602795,1002795,1032379,1022384,377097,487879,469906,754569,964627,279087,864781,293404,229693,515429,209309,977565,176374,754117,934750,542352,1048103,938538,279755,379690,226020,980896,567338,745839,730935,562846,724318,483926,845721,385264,1015163,416328,767604,532897,855264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002317s ]