SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59160 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59160 [ RunTime:0.002185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446235,429252,1010234,218912,478987,583505,590439,73318,713288,332201,404912,973983,728031,917924,677185,566061,697273,205687,974329,435714,944458,836542,761144,711096,518935,549901,510604,592539,300962,156054,783786,738556,135125,402579,355019,866854,898317,711620,643584,762718,45171,173683,932985,406560,329010,872502,847860,984699,536471,810639,1042266,49563,937534,598642,216435,796685,709770,219516,276181,283991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]