SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511898 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511898 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010950,398713,607305,386219,289806,44015,341557,627930,469001,145425,199776,300461,793675,650096,339045,707055,1024167,403065,56191,441336,472294,162970,430252,15052,890280,449345,41803,222542,389169,661313,19766,970003,605694,615421,958894,180784,143356,414617,383958,229011,940218,1016396,766717,11748,36176,30014,317771,864984,391875,746809,213724,132934,290713,712617,36952,824358,172851,972759,310235,1760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]