SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 213203 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 213203 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009699,833028,755233,130917,519444,241985,368218,782622,404652,132105,722042,848068,121574,944412,300265,542687,911046,832296,320029,1037404,788334,1036592,448210,588588,1047570,870845,917903,29584,518702,974941,668207,652714,631634,27884,105520,276941,61169,988304,447469,134643,662883,855166,601544,371939,858702,263450,661159,981827,640918,747425,110367,885040,15890,866440,318076,119308,455547,303808,1027418,630466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 213203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 213203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]