SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507409 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507409 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857053,661770,821847,165944,985980,45060,434864,268887,506366,1004720,28709,224916,123073,1022297,934663,1021019,704173,679355,466936,790138,373146,532087,196049,158299,296726,895719,779406,725047,402565,426583,68309,246384,785779,164591,598039,290956,180896,1040525,258606,224753,267599,613329,512662,113574,738570,199174,501292,336501,984172,58261,518285,7767,404253,651425,575451,820845,1002278,960926,924345,1017741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]