SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001891s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425300 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425300 [ RunTime:0.002611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598077,781613,366771,539861,691052,262734,12571,581197,842499,537741,120908,555273,463049,319531,393146,749529,350525,784637,148529,493284,758365,390582,560839,943898,887232,299002,143007,28270,811717,261587,397021,339085,343152,539136,406667,984386,331609,360409,708255,558461,1004637,392243,71050,586235,461728,759413,850086,947413,259981,491486,473145,566438,356796,348117,254851,588791,402610,746805,830594,489378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004367s ]