SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531824 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531824 [ RunTime:0.003236s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250034,21002,491302,547000,1000988,541829,61423,680539,746427,301168,1003474,593672,810671,46481,38820,149495,379288,743966,242783,933418,874095,511809,124978,273490,239630,98230,911293,756977,976592,447850,318002,10395,720675,672096,506256,1013149,85050,267218,692748,446782,332962,822155,712675,235150,875541,207604,759866,2456,759623,533592,922818,788793,121029,637714,438712,198486,61655,1014469,844991,85017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531824 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531824 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001626s ]