SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 768610 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 768610 [ RunTime:0.002235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644045,429685,643936,891906,861800,969315,986668,295309,272479,312547,494877,261705,1047682,217331,1039738,100355,265007,1027333,1046917,134188,855836,539458,305990,731833,949679,1015702,850847,986026,231996,290043,470916,117722,508044,169518,836670,498499,719411,307414,807262,546369,233844,80907,431067,83894,599028,220152,406459,53071,355647,835453,732643,403691,732901,699121,415575,760733,853323,534403,806279,730779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 768610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 768610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]