SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001739s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35204 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35204 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161280,567578,859635,587309,45839,781838,983186,537581,419979,135436,201588,835816,88296,795467,742112,798539,951233,559,534391,658550,379352,570734,434904,191860,266140,552237,42276,925166,900904,1013468,314845,781755,250142,389206,611640,14172,904282,191327,552548,904832,385253,596074,497340,902021,61951,331866,480124,847096,5119,475647,1040923,106284,721900,352345,235184,755323,845507,715938,17635,810374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]