SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480838 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480838 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178976,447451,723582,854857,215018,412550,229118,886387,140068,745741,818319,655367,55741,946587,457951,605949,198634,543772,565831,391387,850458,685681,841633,31333,669707,999925,1045867,592674,319177,877264,833833,740618,144106,208543,976894,954123,907116,804712,547430,1026970,276003,195271,199905,482207,532482,983107,962716,430787,333916,289085,764766,999243,563693,49199,772660,148750,915688,989720,10216,357218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]