SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001726s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506917 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506917 [ RunTime:0.003924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775258,773458,137808,1030847,110542,738717,505293,717127,865737,205072,1037352,685860,800579,121323,954202,215475,938678,663766,511435,809018,1004387,346027,250741,896857,677538,70681,770259,39353,937102,759249,962513,373977,112497,864338,202860,803017,417348,601953,302010,524016,390452,976454,551794,73078,474624,547520,404279,999575,767131,47360,737491,42117,274304,890949,105656,532907,252533,874496,82661,665454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]