SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43640 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43640 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709208,79150,303154,166338,918503,598891,599422,654494,244034,988915,66514,444245,358894,672535,538171,682105,895081,427573,111974,618968,164279,980734,642746,220668,962134,49971,346324,142063,39111,12941,949573,629761,37119,942245,924904,829136,932982,26711,671618,109649,759311,208069,877734,870297,475654,961778,509713,1019638,291723,834320,638922,930838,492302,211414,301969,573893,509071,342004,562937,916348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]