SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519100 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519100 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93407,857741,545488,920583,61844,331686,309490,175859,424050,296901,675303,360317,951429,40720,251009,993123,892988,326646,921732,681774,241721,712713,1035677,392947,308905,502399,192609,738456,809581,754560,703698,884420,1025213,585460,149539,207523,975761,1021670,233411,731386,275456,222775,557189,174965,1005247,541762,22109,53129,525057,119531,861812,871559,238188,971242,483927,369669,518427,325024,286152,876403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]