SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043822 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043822 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706667,377973,252758,576239,5110,870150,598617,568264,385431,446765,21691,602273,354882,750486,884,510372,218438,141310,78002,63793,611583,113738,788304,848438,7435,142062,475942,900963,260064,148984,774254,467245,877401,661569,507240,414270,963389,55892,629,225925,462437,486936,305799,1029374,24622,981984,228095,35134,619028,287577,959873,349517,587563,711598,950719,927203,401335,894044,383544,728139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]