SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001960s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520834 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520834 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236816,476959,611480,73659,593266,975229,339738,208578,276705,1024314,224631,174498,287632,535213,10936,828946,697943,684540,155216,572534,771622,116926,682744,741088,462936,94017,677341,999906,429646,358272,344385,584720,210904,164600,432616,641475,841261,87460,329127,440362,731312,954197,154699,701489,1019551,407462,733863,612666,80947,458328,798047,758890,1046705,640417,90985,596184,690917,636161,374034,544967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000795s ]