SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001597s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 271995 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 271995 [ RunTime:0.002110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708136,191376,255530,333133,91401,357464,229930,930881,29471,513123,752321,870165,826345,425843,591277,861438,255190,89640,428536,153726,530978,905117,723534,174030,59049,491927,658524,582117,572753,579705,522897,93995,149008,519900,267614,819294,798185,265542,503867,424665,754395,149455,692149,264818,179563,114781,218075,222397,715284,915587,996170,676034,673890,1004975,106569,5952,98835,1041956,655427,11383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 271995 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 271995 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]