SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514312 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514312 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482558,604204,788143,683882,415588,618873,729465,467243,206078,757121,805916,302811,24696,150806,936164,633578,364117,44454,311381,421854,1014804,585580,607443,219783,743183,185159,1017664,491228,500651,904949,285317,571466,466085,137873,1004614,234890,484278,851182,651974,274550,124413,571829,853398,816874,749209,962566,676108,114477,126112,783202,511816,428054,120887,464290,642559,907828,547725,630431,544401,508493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]